package com.woniu.sale.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class PurRequestreturndetailExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Long offset;

    public PurRequestreturndetailExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Long offset) {
        this.offset = offset;
    }

    public Long getOffset() {
        return offset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andBeforepurchasertnnoIsNull() {
            addCriterion("BeforePurchaseRtnNo is null");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoIsNotNull() {
            addCriterion("BeforePurchaseRtnNo is not null");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoEqualTo(String value) {
            addCriterion("BeforePurchaseRtnNo =", value, "beforepurchasertnno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoNotEqualTo(String value) {
            addCriterion("BeforePurchaseRtnNo <>", value, "beforepurchasertnno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoGreaterThan(String value) {
            addCriterion("BeforePurchaseRtnNo >", value, "beforepurchasertnno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoGreaterThanOrEqualTo(String value) {
            addCriterion("BeforePurchaseRtnNo >=", value, "beforepurchasertnno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoLessThan(String value) {
            addCriterion("BeforePurchaseRtnNo <", value, "beforepurchasertnno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoLessThanOrEqualTo(String value) {
            addCriterion("BeforePurchaseRtnNo <=", value, "beforepurchasertnno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoLike(String value) {
            addCriterion("BeforePurchaseRtnNo like", value, "beforepurchasertnno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoNotLike(String value) {
            addCriterion("BeforePurchaseRtnNo not like", value, "beforepurchasertnno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoIn(List<String> values) {
            addCriterion("BeforePurchaseRtnNo in", values, "beforepurchasertnno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoNotIn(List<String> values) {
            addCriterion("BeforePurchaseRtnNo not in", values, "beforepurchasertnno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoBetween(String value1, String value2) {
            addCriterion("BeforePurchaseRtnNo between", value1, value2, "beforepurchasertnno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnnoNotBetween(String value1, String value2) {
            addCriterion("BeforePurchaseRtnNo not between", value1, value2, "beforepurchasertnno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnlnoIsNull() {
            addCriterion("BeforePurchaseRtnLNo is null");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnlnoIsNotNull() {
            addCriterion("BeforePurchaseRtnLNo is not null");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnlnoEqualTo(Integer value) {
            addCriterion("BeforePurchaseRtnLNo =", value, "beforepurchasertnlno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnlnoNotEqualTo(Integer value) {
            addCriterion("BeforePurchaseRtnLNo <>", value, "beforepurchasertnlno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnlnoGreaterThan(Integer value) {
            addCriterion("BeforePurchaseRtnLNo >", value, "beforepurchasertnlno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnlnoGreaterThanOrEqualTo(Integer value) {
            addCriterion("BeforePurchaseRtnLNo >=", value, "beforepurchasertnlno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnlnoLessThan(Integer value) {
            addCriterion("BeforePurchaseRtnLNo <", value, "beforepurchasertnlno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnlnoLessThanOrEqualTo(Integer value) {
            addCriterion("BeforePurchaseRtnLNo <=", value, "beforepurchasertnlno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnlnoIn(List<Integer> values) {
            addCriterion("BeforePurchaseRtnLNo in", values, "beforepurchasertnlno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnlnoNotIn(List<Integer> values) {
            addCriterion("BeforePurchaseRtnLNo not in", values, "beforepurchasertnlno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnlnoBetween(Integer value1, Integer value2) {
            addCriterion("BeforePurchaseRtnLNo between", value1, value2, "beforepurchasertnlno");
            return (Criteria) this;
        }

        public Criteria andBeforepurchasertnlnoNotBetween(Integer value1, Integer value2) {
            addCriterion("BeforePurchaseRtnLNo not between", value1, value2, "beforepurchasertnlno");
            return (Criteria) this;
        }

        public Criteria andProdcdIsNull() {
            addCriterion("ProdCD is null");
            return (Criteria) this;
        }

        public Criteria andProdcdIsNotNull() {
            addCriterion("ProdCD is not null");
            return (Criteria) this;
        }

        public Criteria andProdcdEqualTo(String value) {
            addCriterion("ProdCD =", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdNotEqualTo(String value) {
            addCriterion("ProdCD <>", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdGreaterThan(String value) {
            addCriterion("ProdCD >", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdGreaterThanOrEqualTo(String value) {
            addCriterion("ProdCD >=", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdLessThan(String value) {
            addCriterion("ProdCD <", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdLessThanOrEqualTo(String value) {
            addCriterion("ProdCD <=", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdLike(String value) {
            addCriterion("ProdCD like", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdNotLike(String value) {
            addCriterion("ProdCD not like", value, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdIn(List<String> values) {
            addCriterion("ProdCD in", values, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdNotIn(List<String> values) {
            addCriterion("ProdCD not in", values, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdBetween(String value1, String value2) {
            addCriterion("ProdCD between", value1, value2, "prodcd");
            return (Criteria) this;
        }

        public Criteria andProdcdNotBetween(String value1, String value2) {
            addCriterion("ProdCD not between", value1, value2, "prodcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdIsNull() {
            addCriterion("UnitCD is null");
            return (Criteria) this;
        }

        public Criteria andUnitcdIsNotNull() {
            addCriterion("UnitCD is not null");
            return (Criteria) this;
        }

        public Criteria andUnitcdEqualTo(String value) {
            addCriterion("UnitCD =", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdNotEqualTo(String value) {
            addCriterion("UnitCD <>", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdGreaterThan(String value) {
            addCriterion("UnitCD >", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdGreaterThanOrEqualTo(String value) {
            addCriterion("UnitCD >=", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdLessThan(String value) {
            addCriterion("UnitCD <", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdLessThanOrEqualTo(String value) {
            addCriterion("UnitCD <=", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdLike(String value) {
            addCriterion("UnitCD like", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdNotLike(String value) {
            addCriterion("UnitCD not like", value, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdIn(List<String> values) {
            addCriterion("UnitCD in", values, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdNotIn(List<String> values) {
            addCriterion("UnitCD not in", values, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdBetween(String value1, String value2) {
            addCriterion("UnitCD between", value1, value2, "unitcd");
            return (Criteria) this;
        }

        public Criteria andUnitcdNotBetween(String value1, String value2) {
            addCriterion("UnitCD not between", value1, value2, "unitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdIsNull() {
            addCriterion("BasicUnitCD is null");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdIsNotNull() {
            addCriterion("BasicUnitCD is not null");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdEqualTo(String value) {
            addCriterion("BasicUnitCD =", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdNotEqualTo(String value) {
            addCriterion("BasicUnitCD <>", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdGreaterThan(String value) {
            addCriterion("BasicUnitCD >", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdGreaterThanOrEqualTo(String value) {
            addCriterion("BasicUnitCD >=", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdLessThan(String value) {
            addCriterion("BasicUnitCD <", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdLessThanOrEqualTo(String value) {
            addCriterion("BasicUnitCD <=", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdLike(String value) {
            addCriterion("BasicUnitCD like", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdNotLike(String value) {
            addCriterion("BasicUnitCD not like", value, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdIn(List<String> values) {
            addCriterion("BasicUnitCD in", values, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdNotIn(List<String> values) {
            addCriterion("BasicUnitCD not in", values, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdBetween(String value1, String value2) {
            addCriterion("BasicUnitCD between", value1, value2, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andBasicunitcdNotBetween(String value1, String value2) {
            addCriterion("BasicUnitCD not between", value1, value2, "basicunitcd");
            return (Criteria) this;
        }

        public Criteria andLotnoIsNull() {
            addCriterion("LotNo is null");
            return (Criteria) this;
        }

        public Criteria andLotnoIsNotNull() {
            addCriterion("LotNo is not null");
            return (Criteria) this;
        }

        public Criteria andLotnoEqualTo(String value) {
            addCriterion("LotNo =", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoNotEqualTo(String value) {
            addCriterion("LotNo <>", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoGreaterThan(String value) {
            addCriterion("LotNo >", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoGreaterThanOrEqualTo(String value) {
            addCriterion("LotNo >=", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoLessThan(String value) {
            addCriterion("LotNo <", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoLessThanOrEqualTo(String value) {
            addCriterion("LotNo <=", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoLike(String value) {
            addCriterion("LotNo like", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoNotLike(String value) {
            addCriterion("LotNo not like", value, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoIn(List<String> values) {
            addCriterion("LotNo in", values, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoNotIn(List<String> values) {
            addCriterion("LotNo not in", values, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoBetween(String value1, String value2) {
            addCriterion("LotNo between", value1, value2, "lotno");
            return (Criteria) this;
        }

        public Criteria andLotnoNotBetween(String value1, String value2) {
            addCriterion("LotNo not between", value1, value2, "lotno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoIsNull() {
            addCriterion("PurchaseNo is null");
            return (Criteria) this;
        }

        public Criteria andPurchasenoIsNotNull() {
            addCriterion("PurchaseNo is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasenoEqualTo(String value) {
            addCriterion("PurchaseNo =", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotEqualTo(String value) {
            addCriterion("PurchaseNo <>", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoGreaterThan(String value) {
            addCriterion("PurchaseNo >", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoGreaterThanOrEqualTo(String value) {
            addCriterion("PurchaseNo >=", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoLessThan(String value) {
            addCriterion("PurchaseNo <", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoLessThanOrEqualTo(String value) {
            addCriterion("PurchaseNo <=", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoLike(String value) {
            addCriterion("PurchaseNo like", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotLike(String value) {
            addCriterion("PurchaseNo not like", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoIn(List<String> values) {
            addCriterion("PurchaseNo in", values, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotIn(List<String> values) {
            addCriterion("PurchaseNo not in", values, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoBetween(String value1, String value2) {
            addCriterion("PurchaseNo between", value1, value2, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotBetween(String value1, String value2) {
            addCriterion("PurchaseNo not between", value1, value2, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andRtnqntyIsNull() {
            addCriterion("RtnQnty is null");
            return (Criteria) this;
        }

        public Criteria andRtnqntyIsNotNull() {
            addCriterion("RtnQnty is not null");
            return (Criteria) this;
        }

        public Criteria andRtnqntyEqualTo(Integer value) {
            addCriterion("RtnQnty =", value, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyNotEqualTo(Integer value) {
            addCriterion("RtnQnty <>", value, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyGreaterThan(Integer value) {
            addCriterion("RtnQnty >", value, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("RtnQnty >=", value, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyLessThan(Integer value) {
            addCriterion("RtnQnty <", value, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyLessThanOrEqualTo(Integer value) {
            addCriterion("RtnQnty <=", value, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyIn(List<Integer> values) {
            addCriterion("RtnQnty in", values, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyNotIn(List<Integer> values) {
            addCriterion("RtnQnty not in", values, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyBetween(Integer value1, Integer value2) {
            addCriterion("RtnQnty between", value1, value2, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("RtnQnty not between", value1, value2, "rtnqnty");
            return (Criteria) this;
        }

        public Criteria andRtnqntybasicIsNull() {
            addCriterion("RtnQntyBasic is null");
            return (Criteria) this;
        }

        public Criteria andRtnqntybasicIsNotNull() {
            addCriterion("RtnQntyBasic is not null");
            return (Criteria) this;
        }

        public Criteria andRtnqntybasicEqualTo(Integer value) {
            addCriterion("RtnQntyBasic =", value, "rtnqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnqntybasicNotEqualTo(Integer value) {
            addCriterion("RtnQntyBasic <>", value, "rtnqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnqntybasicGreaterThan(Integer value) {
            addCriterion("RtnQntyBasic >", value, "rtnqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnqntybasicGreaterThanOrEqualTo(Integer value) {
            addCriterion("RtnQntyBasic >=", value, "rtnqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnqntybasicLessThan(Integer value) {
            addCriterion("RtnQntyBasic <", value, "rtnqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnqntybasicLessThanOrEqualTo(Integer value) {
            addCriterion("RtnQntyBasic <=", value, "rtnqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnqntybasicIn(List<Integer> values) {
            addCriterion("RtnQntyBasic in", values, "rtnqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnqntybasicNotIn(List<Integer> values) {
            addCriterion("RtnQntyBasic not in", values, "rtnqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnqntybasicBetween(Integer value1, Integer value2) {
            addCriterion("RtnQntyBasic between", value1, value2, "rtnqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnqntybasicNotBetween(Integer value1, Integer value2) {
            addCriterion("RtnQntyBasic not between", value1, value2, "rtnqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntyIsNull() {
            addCriterion("RtnConfirmQnty is null");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntyIsNotNull() {
            addCriterion("RtnConfirmQnty is not null");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntyEqualTo(Integer value) {
            addCriterion("RtnConfirmQnty =", value, "rtnconfirmqnty");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntyNotEqualTo(Integer value) {
            addCriterion("RtnConfirmQnty <>", value, "rtnconfirmqnty");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntyGreaterThan(Integer value) {
            addCriterion("RtnConfirmQnty >", value, "rtnconfirmqnty");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntyGreaterThanOrEqualTo(Integer value) {
            addCriterion("RtnConfirmQnty >=", value, "rtnconfirmqnty");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntyLessThan(Integer value) {
            addCriterion("RtnConfirmQnty <", value, "rtnconfirmqnty");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntyLessThanOrEqualTo(Integer value) {
            addCriterion("RtnConfirmQnty <=", value, "rtnconfirmqnty");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntyIn(List<Integer> values) {
            addCriterion("RtnConfirmQnty in", values, "rtnconfirmqnty");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntyNotIn(List<Integer> values) {
            addCriterion("RtnConfirmQnty not in", values, "rtnconfirmqnty");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntyBetween(Integer value1, Integer value2) {
            addCriterion("RtnConfirmQnty between", value1, value2, "rtnconfirmqnty");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntyNotBetween(Integer value1, Integer value2) {
            addCriterion("RtnConfirmQnty not between", value1, value2, "rtnconfirmqnty");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntybasicIsNull() {
            addCriterion("RtnConfirmQntyBasic is null");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntybasicIsNotNull() {
            addCriterion("RtnConfirmQntyBasic is not null");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntybasicEqualTo(Integer value) {
            addCriterion("RtnConfirmQntyBasic =", value, "rtnconfirmqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntybasicNotEqualTo(Integer value) {
            addCriterion("RtnConfirmQntyBasic <>", value, "rtnconfirmqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntybasicGreaterThan(Integer value) {
            addCriterion("RtnConfirmQntyBasic >", value, "rtnconfirmqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntybasicGreaterThanOrEqualTo(Integer value) {
            addCriterion("RtnConfirmQntyBasic >=", value, "rtnconfirmqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntybasicLessThan(Integer value) {
            addCriterion("RtnConfirmQntyBasic <", value, "rtnconfirmqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntybasicLessThanOrEqualTo(Integer value) {
            addCriterion("RtnConfirmQntyBasic <=", value, "rtnconfirmqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntybasicIn(List<Integer> values) {
            addCriterion("RtnConfirmQntyBasic in", values, "rtnconfirmqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntybasicNotIn(List<Integer> values) {
            addCriterion("RtnConfirmQntyBasic not in", values, "rtnconfirmqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntybasicBetween(Integer value1, Integer value2) {
            addCriterion("RtnConfirmQntyBasic between", value1, value2, "rtnconfirmqntybasic");
            return (Criteria) this;
        }

        public Criteria andRtnconfirmqntybasicNotBetween(Integer value1, Integer value2) {
            addCriterion("RtnConfirmQntyBasic not between", value1, value2, "rtnconfirmqntybasic");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceIsNull() {
            addCriterion("PurchasePrice is null");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceIsNotNull() {
            addCriterion("PurchasePrice is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceEqualTo(BigDecimal value) {
            addCriterion("PurchasePrice =", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceNotEqualTo(BigDecimal value) {
            addCriterion("PurchasePrice <>", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceGreaterThan(BigDecimal value) {
            addCriterion("PurchasePrice >", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PurchasePrice >=", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceLessThan(BigDecimal value) {
            addCriterion("PurchasePrice <", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PurchasePrice <=", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceIn(List<BigDecimal> values) {
            addCriterion("PurchasePrice in", values, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceNotIn(List<BigDecimal> values) {
            addCriterion("PurchasePrice not in", values, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PurchasePrice between", value1, value2, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PurchasePrice not between", value1, value2, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andTaxIsNull() {
            addCriterion("Tax is null");
            return (Criteria) this;
        }

        public Criteria andTaxIsNotNull() {
            addCriterion("Tax is not null");
            return (Criteria) this;
        }

        public Criteria andTaxEqualTo(BigDecimal value) {
            addCriterion("Tax =", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotEqualTo(BigDecimal value) {
            addCriterion("Tax <>", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxGreaterThan(BigDecimal value) {
            addCriterion("Tax >", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Tax >=", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxLessThan(BigDecimal value) {
            addCriterion("Tax <", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Tax <=", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxIn(List<BigDecimal> values) {
            addCriterion("Tax in", values, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotIn(List<BigDecimal> values) {
            addCriterion("Tax not in", values, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Tax between", value1, value2, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Tax not between", value1, value2, "tax");
            return (Criteria) this;
        }

        public Criteria andTotalmnyIsNull() {
            addCriterion("TotalMny is null");
            return (Criteria) this;
        }

        public Criteria andTotalmnyIsNotNull() {
            addCriterion("TotalMny is not null");
            return (Criteria) this;
        }

        public Criteria andTotalmnyEqualTo(BigDecimal value) {
            addCriterion("TotalMny =", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyNotEqualTo(BigDecimal value) {
            addCriterion("TotalMny <>", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyGreaterThan(BigDecimal value) {
            addCriterion("TotalMny >", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TotalMny >=", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyLessThan(BigDecimal value) {
            addCriterion("TotalMny <", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TotalMny <=", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyIn(List<BigDecimal> values) {
            addCriterion("TotalMny in", values, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyNotIn(List<BigDecimal> values) {
            addCriterion("TotalMny not in", values, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TotalMny between", value1, value2, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TotalMny not between", value1, value2, "totalmny");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}